use sms_d
GRANT EXECUTE TO Executer
CREATE USER Terminal for LOGIN  Terminal;
CREATE ROLE [TerminalRole] AUTHORIZATION [dbo]
EXEC dbo.sp_addrolemember @rolename=N'TerminalRole', @membername=N'Terminal'
EXEC dbo.sp_addrolemember @rolename=N'Executer', @membername=N'Terminal'

